﻿
using System;
using System.Data;
using System.Data.SqlClient;
namespace Model
{
	
	/// <summary>	 
	/// 产品信息表
	/// </summary>
	public class DbProducts
	{ 
		#region DbProducts
		/// <summary>
		/// 
		/// </summary>
		public DbProducts()
		{
		}
		/// <summary>	 
		/// 
		/// </summary>
		public DbProducts(Int32 pId)
		{
			this.pId = pId;
		
		}
		/// <summary>	 
		/// 
		/// </summary>		
		public DbProducts(DataRow dr)
		{
			int.TryParse(Convert.ToString(dr["pId"]),out pId);
			this.pName = Convert.ToString(dr["pName"]);
			this.pCode = Convert.ToString(dr["pCode"]);
			int.TryParse(Convert.ToString(dr["pClassId"]),out pClassId);
			this.pAllClassIds = Convert.ToString(dr["pAllClassIds"]);
			this.pKeywords = Convert.ToString(dr["pKeywords"]);
			this.pDescription = Convert.ToString(dr["pDescription"]);
			this.pNote = Convert.ToString(dr["pNote"]);
			this.pMarketPrice = Convert.ToString(dr["pMarketPrice"]);
			this.pUserPrice = Convert.ToString(dr["pUserPrice"]);
			this.pDefaultImg = Convert.ToString(dr["pDefaultImg"]);
			this.pBigDefaultImg = Convert.ToString(dr["pBigDefaultImg"]);
			this.pSmallDefaultImg = Convert.ToString(dr["pSmallDefaultImg"]);
			int.TryParse(Convert.ToString(dr["pOrder"]),out pOrder);
			this.pStatus = Convert.ToInt16(dr["pStatus"]);
			this.pIsHot = Convert.ToInt16(dr["pIsHot"]);
			int.TryParse(Convert.ToString(dr["pHits"]),out pHits);
			this.pIsNews = Convert.ToInt16(dr["pIsNews"]);
			if(dr["pAddTime"] != DBNull.Value)
				this.pAddTime = Convert.ToDateTime(dr["pAddTime"]);
			this.pShortInstr = Convert.ToString(dr["pShortInstr"]);
			int.TryParse(Convert.ToString(dr["pStoreAmount"]),out pStoreAmount);
			this.pWeight = Convert.ToString(dr["pWeight"]);
			this.pDesigner = Convert.ToString(dr["pDesigner"]);
			this.pSizeFit = Convert.ToString(dr["pSizeFit"]);
			this.pShippingReturns = Convert.ToString(dr["pShippingReturns"]);
			
		}
		#endregion
		
		
		#region PId
		private Int32 pId;
		/// <summary>	 
		/// 
		/// AutoInc
		/// PK
		/// </summary>
		public Int32 PId
		{
			get{ return pId; }
			set{ pId= value; }
		}
		#endregion
		
		#region PName
		private System.String pName;
		/// <summary>	 
		/// 产品名称
		/// </summary>
		public System.String PName
		{
			get{ return pName; }
			set{ pName= value; }
		}
		#endregion
		
		#region PCode
		private System.String pCode;
		/// <summary>	 
		/// 产品编号
		/// </summary>
		public System.String PCode
		{
			get{ return pCode; }
			set{ pCode= value; }
		}
		#endregion
		
		#region PClassId
		private Int32 pClassId;
		/// <summary>	 
		/// 产品类别
		/// </summary>
		public Int32 PClassId
		{
			get{ return pClassId; }
			set{ pClassId= value; }
		}
		#endregion
		
		#region PAllClassIds
		private System.String pAllClassIds;
		/// <summary>	 
		/// 类别Id
		/// </summary>
		public System.String PAllClassIds
		{
			get{ return pAllClassIds; }
			set{ pAllClassIds= value; }
		}
		#endregion
		
		#region PKeywords
		private System.String pKeywords;
		/// <summary>	 
		/// 产品关键词
		/// </summary>
		public System.String PKeywords
		{
			get{ return pKeywords; }
			set{ pKeywords= value; }
		}
		#endregion
		
		#region PDescription
		private System.String pDescription;
		/// <summary>	 
		/// 产品优化描述
		/// </summary>
		public System.String PDescription
		{
			get{ return pDescription; }
			set{ pDescription= value; }
		}
		#endregion
		
		#region PNote
		private System.String pNote;
		/// <summary>	 
		/// 产品说明
		/// </summary>
		public System.String PNote
		{
			get{ return pNote; }
			set{ pNote= value; }
		}
		#endregion
		
		#region PMarketPrice
		private System.String pMarketPrice;
		/// <summary>	 
		/// 市场价
		/// </summary>
		public System.String PMarketPrice
		{
			get{ return pMarketPrice; }
			set{ pMarketPrice= value; }
		}
		#endregion
		
		#region PUserPrice
		private System.String pUserPrice;
		/// <summary>	 
		/// 会员价
		/// </summary>
		public System.String PUserPrice
		{
			get{ return pUserPrice; }
			set{ pUserPrice= value; }
		}
		#endregion
		
		#region PDefaultImg
		private System.String pDefaultImg;
		/// <summary>	 
		/// 默认略图
		/// </summary>
		public System.String PDefaultImg
		{
			get{ return pDefaultImg; }
			set{ pDefaultImg= value; }
		}
		#endregion
		
		#region PBigDefaultImg
		private System.String pBigDefaultImg;
		/// <summary>	 
		/// 默认放大图
		/// </summary>
		public System.String PBigDefaultImg
		{
			get{ return pBigDefaultImg; }
			set{ pBigDefaultImg= value; }
		}
		#endregion
		
		#region PSmallDefaultImg
		private System.String pSmallDefaultImg;
		/// <summary>	 
		/// 默认略小图
		/// </summary>
		public System.String PSmallDefaultImg
		{
			get{ return pSmallDefaultImg; }
			set{ pSmallDefaultImg= value; }
		}
		#endregion
		
		#region POrder
		private Int32 pOrder;
		/// <summary>	 
		/// 排序
		/// </summary>
		public Int32 POrder
		{
			get{ return pOrder; }
			set{ pOrder= value; }
		}
		#endregion
		
		#region PStatus
		private Int16 pStatus;
		/// <summary>	 
		/// 状态
		/// </summary>
		public Int16 PStatus
		{
			get{ return pStatus; }
			set{ pStatus= value; }
		}
		#endregion
		
		#region PIsHot
		private Int16 pIsHot;
		/// <summary>	 
		/// 是否热销产品
		/// </summary>
		public Int16 PIsHot
		{
			get{ return pIsHot; }
			set{ pIsHot= value; }
		}
		#endregion
		
		#region PHits
		private Int32 pHits;
		/// <summary>	 
		/// 产品访问次数
		/// </summary>
		public Int32 PHits
		{
			get{ return pHits; }
			set{ pHits= value; }
		}
		#endregion
		
		#region PIsNews
		private Int16 pIsNews;
		/// <summary>	 
		/// 是否新品
		/// </summary>
		public Int16 PIsNews
		{
			get{ return pIsNews; }
			set{ pIsNews= value; }
		}
		#endregion
		
		#region PAddTime
		private DateTime pAddTime;
		/// <summary>	 
		/// 添加时间
		/// </summary>
		public DateTime PAddTime
		{
			get{ return pAddTime; }
			set{ pAddTime= value; }
		}
		#endregion
		
		#region PShortInstr
		private System.String pShortInstr;
		/// <summary>	 
		/// 产品概要
		/// </summary>
		public System.String PShortInstr
		{
			get{ return pShortInstr; }
			set{ pShortInstr= value; }
		}
		#endregion
		
		#region PStoreAmount
		private Int32 pStoreAmount;
		/// <summary>	 
		/// 库存
		/// </summary>
		public Int32 PStoreAmount
		{
			get{ return pStoreAmount; }
			set{ pStoreAmount= value; }
		}
		#endregion
		
		#region PWeight
		private System.String pWeight;
		/// <summary>	 
		/// 重量
		/// </summary>
		public System.String PWeight
		{
			get{ return pWeight; }
			set{ pWeight= value; }
		}
		#endregion
		
		#region PDesigner
		private System.String pDesigner;
		/// <summary>	 
		/// 设计者
		/// </summary>
		public System.String PDesigner
		{
			get{ return pDesigner; }
			set{ pDesigner= value; }
		}
		#endregion
		
		#region PSizeFit
		private System.String pSizeFit;
		/// <summary>	 
		/// 尺寸
		/// </summary>
		public System.String PSizeFit
		{
			get{ return pSizeFit; }
			set{ pSizeFit= value; }
		}
		#endregion
		
		#region PShippingReturns
		private System.String pShippingReturns;
		/// <summary>	 
		/// 货运及退货
		/// </summary>
		public System.String PShippingReturns
		{
			get{ return pShippingReturns; }
			set{ pShippingReturns= value; }
		}
		#endregion

	}
}
